/*
 * Licensed to the Apache Software Foundation (ASF) under one or more
 * contributor license agreements.  See the NOTICE file distributed with
 * this work for additional information regarding copyright ownership.
 * The ASF licenses this file to You under the Apache License, Version 2.0
 * (the "License"); you may not use this file except in compliance with
 * the License.  You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package org.apache.ranger.db;

import org.apache.ranger.common.db.BaseDao;
import org.apache.ranger.entity.XXService;
import org.apache.ranger.plugin.model.RangerServiceHeaderInfo;
import org.springframework.stereotype.Service;

import javax.persistence.NoResultException;

import java.util.ArrayList;
import java.util.Collections;
import java.util.List;

/**
 *
 */

@Service
public class XXServiceDao extends BaseDao<XXService> {
    /**
     * Default Constructor
     */
    public XXServiceDao(RangerDaoManagerBase daoManager) {
        super(daoManager);
    }

    public Long findIdByName(String name) {
        Long ret = null;

        if (name != null) {
            try {
                ret = getEntityManager()
                        .createNamedQuery("XXService.findIdByName", Long.class)
                        .setParameter("name", name).getSingleResult();
            } catch (NoResultException e) {
                // ignore
            }
        }

        return ret;
    }

    public XXService findByName(String name) {
        if (name == null) {
            return null;
        }
        try {
            return getEntityManager()
                    .createNamedQuery("XXService.findByName", tClass)
                    .setParameter("name", name).getSingleResult();
        } catch (NoResultException e) {
            return null;
        }
    }

    public XXService findByDisplayName(String displayName) {
        if (displayName == null) {
            return null;
        }

        try {
            return getEntityManager()
                    .createNamedQuery("XXService.findByDisplayName", tClass)
                    .setParameter("displayName", displayName).getSingleResult();
        } catch (NoResultException e) {
            return null;
        }
    }

    public Long getMaxIdOfXXService() {
        try {
            return (Long) getEntityManager().createNamedQuery("XXService.getMaxIdOfXXService").getSingleResult();
        } catch (NoResultException e) {
            return null;
        }
    }

    public List<XXService> findByServiceDefId(Long serviceDefId) {
        if (serviceDefId == null) {
            return new ArrayList<>();
        }

        try {
            return getEntityManager().createNamedQuery("XXService.findByServiceDefId", tClass)
                    .setParameter("serviceDefId", serviceDefId).getResultList();
        } catch (NoResultException e) {
            return new ArrayList<>();
        }
    }

    public List<XXService> findByTagServiceId(Long tagServiceId) {
        if (tagServiceId == null) {
            return new ArrayList<>();
        }

        try {
            return getEntityManager().createNamedQuery("XXService.findByTagServiceId", tClass)
                    .setParameter("tagServiceId", tagServiceId).getResultList();
        } catch (NoResultException e) {
            return new ArrayList<>();
        }
    }

    public List<Long> findIdsByTagServiceId(Long tagServiceId) {
        List<Long> ret = null;

        try {
            ret = getEntityManager().createNamedQuery("XXService.findIdsByTagServiceId", Long.class)
                    .setParameter("tagServiceId", tagServiceId).getResultList();
        } catch (NoResultException e) {
            // ignre
        }

        return ret != null ? ret : Collections.emptyList();
    }

    public XXService findAssociatedTagService(String serviceName) {
        try {
            return getEntityManager().createNamedQuery("XXService.findAssociatedTagService", tClass)
                    .setParameter("serviceName", serviceName).getSingleResult();
        } catch (NoResultException e) {
            return null;
        }
    }

    public List<XXService> getAllServicesWithTagService() {
        try {
            return getEntityManager().createNamedQuery("XXService.getAllServicesWithTagService", tClass)
                    .getResultList();
        } catch (NoResultException e) {
            return new ArrayList<>();
        }
    }

    public void updateSequence() {
        Long maxId = getMaxIdOfXXService();

        if (maxId == null) {
            return;
        }

        updateSequence("X_SERVICE_SEQ", maxId + 1);
    }

    public List<Long> getAllServiceIds() {
        try {
            return getEntityManager().createNamedQuery("XXService.getAllServiceIds", Long.class)
                    .getResultList();
        } catch (NoResultException e) {
            return new ArrayList<>();
        }
    }

    public List<RangerServiceHeaderInfo> findServiceHeaders() {
        List<RangerServiceHeaderInfo> ret;

        try {
            List<Object[]> results = getEntityManager().createNamedQuery("XXService.getAllServiceHeaders", Object[].class).getResultList();

            ret = new ArrayList<>(results.size());

            for (Object[] result : results) {
                ret.add(new RangerServiceHeaderInfo((Long) result[0], (String) result[1], (String) result[2], (String) result[3], (Boolean) result[4]));
            }
        } catch (NoResultException excp) {
            ret = Collections.emptyList();
        }

        return ret;
    }
}
